SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506446 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506446 [ RunTime:0.001659s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (976417,500885,931099,457207,233642,426624,152762,340116,861462,253114,621824,939327,536162,790004,659029,419246,380391,627569,160278,469859,291542,521305,289220,417087,58600,74649,711854,892485,978341,692377,760960,424029,434239,131964,218206,690501,255245,868566,326052,1038017,1030852,913864,755207,450732,109082,609144,469383,897450,678332,261973,489183,744148,797411,34718,715285,486677,202669,22175,560406,78352) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506446 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506446 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000441s ]