SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 478015 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 478015 [ RunTime:0.003161s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1000011,57129,236447,1026948,408227,935916,866943,362653,584146,555499,340711,502632,749314,567656,817400,897115,922347,627544,422896,998868,392953,180076,464029,510174,541555,981812,705739,294949,933409,782651,283876,841704,1003294,866068,332729,280791,882923,510098,17711,733096,454541,620318,662347,62184,135269,454952,350906,99492,425393,112902,59837,442651,578950,509792,663191,943059,815197,686612,904765,31041) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 478015 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 478015 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002236s ]