SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001903s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 553523 LIMIT 1 [ RunTime:0.000968s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 553523 [ RunTime:0.002898s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (125080,272462,805721,578085,1007091,914738,782321,696282,466034,868524,503329,408133,519068,980765,982590,935564,778394,899792,810219,246107,553118,104149,19604,535498,337767,252364,294824,274338,609173,392488,805312,734708,880147,880312,868877,317572,745327,588636,11772,1041216,1046622,817518,1013296,491676,490124,365928,622995,969687,110066,137036,336290,53114,613509,796950,171746,879279,232498,48660,227117,239153) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.010306s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 553523 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 553523 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]