SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003456s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 493811 LIMIT 1 [ RunTime:0.002393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 493811 [ RunTime:0.001515s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (779594,131439,250636,7228,71297,339904,223106,683330,402054,955503,437697,486146,787421,1041435,101404,68987,62114,506459,177055,614829,223989,415866,261237,933357,956713,615012,14892,687779,168800,150867,213632,797083,373995,858820,778209,515170,351727,173332,955225,951059,887586,966633,308992,307863,747359,404318,252643,740899,332982,696262,817333,844006,396587,401209,27695,892331,905916,28412,277838,515364) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 493811 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000451s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 493811 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000616s ]