SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544610 LIMIT 1 [ RunTime:0.000414s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544610 [ RunTime:0.001772s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (743205,323383,964281,781790,819942,638220,492909,50584,397078,987986,224654,803333,607719,200772,683404,540945,802285,878659,672156,659456,474001,1038465,149043,977179,659232,691664,608923,875095,511829,232880,435472,164662,378436,599235,749982,115485,876108,399803,861442,426314,226733,736598,279158,699838,770518,969752,1046486,805424,192046,588005,238451,144900,541144,73641,91534,332555,837934,418869,639173,818236) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544610 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000621s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544610 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]