SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1026468 LIMIT 1 [ RunTime:0.000800s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1026468 [ RunTime:0.002543s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (280417,795604,743860,362100,896625,831810,616013,935332,96718,1002388,646878,763390,762539,111675,1047493,754640,741904,1042792,910195,882438,113935,560664,832562,928605,348402,289213,785516,933011,748063,351319,469362,540277,89891,500973,821106,593966,753064,466878,435677,790229,139932,987832,1012051,1023330,707063,28145,144145,792805,219106,428253,1010190,179702,188092,679755,438095,177198,567894,284832,909441,347415) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1026468 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1026468 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]