SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1015980 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1015980 [ RunTime:0.001414s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (464492,214123,107326,132767,704875,2332,233436,830000,865774,318439,343250,1045766,163509,128904,409275,521467,231545,876161,1006230,389860,148788,408769,534818,421947,26556,326654,658639,402737,443817,96965,514414,954440,140362,639110,875044,66436,776657,353997,821764,358571,358124,589485,512572,73112,733166,689810,715584,139901,680439,479274,500309,667046,551935,704376,274108,892881,613740,329985,1001070,96223) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001002s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1015980 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1015980 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000513s ]