SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504144 LIMIT 1 [ RunTime:0.000441s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504144 [ RunTime:0.002185s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (505483,429030,686779,84435,521794,137635,990702,796777,57224,123239,908650,58435,73061,46829,1001072,709961,708970,443933,650588,645540,43519,312261,358161,759355,863663,154989,268176,276020,32788,68495,67526,904080,411767,672243,372331,720722,2371,557109,29096,554220,56151,29948,601187,287626,131477,562010,470710,210840,730241,293464,200312,50980,334700,447993,452118,103341,425176,46862,544092,477206) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002087s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504144 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504144 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002333s ]