SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001460s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402244 LIMIT 1 [ RunTime:0.000423s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402244 [ RunTime:0.001641s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (662083,1018974,413603,53115,764144,1005427,201882,1007817,917718,112937,904101,844064,950849,1000322,965456,171090,117443,167242,134254,474314,1014484,190796,384541,915352,685583,937620,331311,284621,633798,373172,941655,438908,929870,248711,828796,466572,943718,244757,319658,485272,720613,863215,90194,934275,147722,713284,195829,54035,485606,492728,271614,22297,563867,359653,1023786,408120,502454,753109,166520,644523) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402244 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402244 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000442s ]