SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001386s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1016628 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1016628 [ RunTime:0.005304s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (808993,541357,162917,292617,860667,538023,432759,932664,100915,347007,750959,635985,918471,885904,969817,709196,753919,915174,249347,401940,869561,190814,89174,526440,987585,830895,195079,234471,902894,846211,787277,149638,640564,927759,806073,379585,521912,498461,74287,784812,528038,238070,1005430,402697,95061,58261,173917,251179,665373,71563,773328,471629,908356,664301,112894,973042,646820,218931,956758,869345) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001002s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1016628 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002581s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1016628 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000630s ]