SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804022 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804022 [ RunTime:0.002423s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (967397,986359,126140,360625,325638,258222,977303,214596,204486,750629,337910,738577,319515,893724,333483,306096,634541,552179,62732,879894,133980,223372,456689,903297,239716,911995,744353,534772,961888,690816,676857,316526,341748,686832,807695,1004018,250143,94860,670615,549695,23065,324830,432599,616439,621342,549948,385961,103871,552282,159792,287257,284484,508601,236044,219674,33266,413484,938549,842808,551525) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001058s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804022 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804022 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000587s ]