SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001508s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 681457 LIMIT 1 [ RunTime:0.000474s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 681457 [ RunTime:0.007830s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (879997,449001,128284,131453,631428,298117,386054,712171,72223,421179,1038173,607805,279458,741034,1031626,998825,919764,660123,860940,183250,38775,82877,49597,552315,919445,327213,448046,667101,646539,92077,1007671,835931,693550,157866,295695,997040,245288,688788,913393,817209,732466,1016630,481925,813165,1010926,218021,945407,253194,936632,662076,740842,925670,614246,963260,277561,170078,577702,27101,784672,484319) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 681457 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001321s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 681457 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002867s ]