SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001386s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 605091 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 605091 [ RunTime:0.001789s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (899416,828719,747801,470747,984422,769705,48975,418235,957793,947818,782106,436592,16708,190311,603728,459119,245394,460450,1045067,1016819,896492,96868,915406,874123,1029931,824832,525573,742877,367936,902283,891828,705234,110890,502594,905137,514871,773336,350729,21820,510820,570239,501661,34765,784514,588845,477939,993985,869628,981221,953778,518253,1007669,314238,1046587,216275,480050,379181,275884,474276,343287) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002283s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 605091 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 605091 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]