SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 38060 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 38060 [ RunTime:0.001705s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (802612,15964,954713,223524,999174,792450,814267,990526,287081,966143,1046868,753651,525561,598859,522932,1016517,299098,760369,385608,643627,112284,772107,989730,603674,700996,386827,55182,522936,449692,750880,912748,751945,718801,669851,2383,678426,294107,451167,868587,561435,839072,1039192,501197,945729,643897,1029371,575378,976031,328524,371325,150846,960245,740646,67744,175241,471661,338071,971045,785885,456425) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000976s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 38060 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 38060 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000390s ]