SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 68330 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 68330 [ RunTime:0.001779s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (200900,624601,437506,616084,298387,565066,552582,421098,681385,388520,412015,780435,591525,230850,965274,682420,629642,553776,896326,693403,848542,300715,715638,604534,112621,177614,607331,290452,104788,346670,616395,947626,716505,133586,620632,406017,140198,129062,243269,457798,689356,953225,687434,433492,67668,220655,769758,523722,420289,570039,792201,35171,914294,300407,643255,1028133,768536,927053,79373,305889) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 68330 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 68330 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]