SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1037296 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1037296 [ RunTime:0.001605s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (126312,405462,703712,139318,622569,736332,482319,270088,605969,182912,983344,954055,595821,125811,95736,782377,751309,849315,898022,704514,829049,891533,620983,737727,342176,585601,214847,219399,711489,236968,995068,20369,582851,811039,668002,687902,436180,595314,158163,69754,662334,78259,960954,559368,670258,623156,104971,525046,728706,1000714,385806,425885,544677,725222,913881,573359,13043,767778,116173,867346) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001022s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1037296 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1037296 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]