SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 72106 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 72106 [ RunTime:0.001666s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (556861,491079,145635,813810,372961,669610,142049,900433,147482,398059,80742,282384,1045771,311105,214552,1047853,114484,550019,798066,42918,496177,166436,968821,427549,475190,687783,755709,663230,310518,409509,426946,703786,660896,548391,448001,433644,5279,515663,104688,550912,97966,280057,672951,456459,912294,1004860,406160,757335,753673,155832,126266,520929,12522,323310,23782,951250,855213,231117,283099,453940) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001053s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 72106 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000315s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 72106 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000461s ]