SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001341s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 8899 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 8899 [ RunTime:0.001890s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (125213,878822,355373,882546,247237,784098,697618,143974,451670,1009026,494937,282931,163092,928102,59611,303145,139101,505890,604685,222480,984081,115044,427365,460571,739024,70641,85952,344941,94551,15481,594353,854393,560822,667072,902142,129369,534827,539926,159242,511092,691390,835069,603351,374203,634886,1047799,149077,733058,218983,1020263,357866,76497,153323,724068,427732,47559,875136,160648,146948,154446) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001018s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 8899 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000326s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 8899 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]