SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 500840 LIMIT 1 [ RunTime:0.000968s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 500840 [ RunTime:0.006007s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (185446,788361,910179,905656,757268,135339,116851,793525,580059,445421,1025028,184148,234657,473802,339238,552836,556884,503545,825991,516206,218071,884148,711589,709575,998893,754405,791357,411535,370224,181111,556522,92532,620032,262700,988270,436471,13783,96794,980602,841732,968188,857572,552971,724248,633040,465335,88745,629230,96104,909774,642219,944528,114909,678097,645168,450769,281970,294392,741725,171404) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001870s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 500840 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001074s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 500840 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003101s ]