SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001831s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 398872 LIMIT 1 [ RunTime:0.000297s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 398872 [ RunTime:0.001727s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (318307,606998,652079,348848,424677,1017535,846475,79953,315445,723996,944119,552364,868127,4348,238758,984186,198780,809234,583309,718310,1030599,539233,426111,328657,360545,254140,889120,744691,331581,1037036,347120,910417,950369,262353,752116,558779,14775,824781,879903,186574,498410,1020437,890388,924509,559675,223654,663531,348067,713057,856986,384926,490337,936700,52361,181109,842012,904514,875512,611092,48670) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 398872 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 398872 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000631s ]