SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002057s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 519599 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 519599 [ RunTime:0.001631s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (141969,971192,532656,94142,351508,617353,283866,392120,347778,215970,703416,850812,240333,293247,203309,332259,543210,971208,784042,315490,897948,1030906,218326,236111,313760,767958,170519,803075,979965,199752,77497,935169,307400,844540,514994,1022495,650142,826478,524775,942832,1020936,525967,650869,1040815,736609,349485,47287,626068,151345,64916,642055,834355,805642,724468,329676,166054,753573,415122,422860,1035207) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001036s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 519599 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 519599 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000541s ]