SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540765 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540765 [ RunTime:0.001598s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (668694,1015199,11833,360106,233554,966819,888911,667239,315873,762505,465781,472002,234043,515442,664808,196111,894631,765909,538088,185295,69159,244800,916433,767141,4897,258320,68591,799633,201568,74810,801321,101054,757795,710290,1023250,291172,1013542,345632,452258,259377,387444,966159,322499,721216,467121,1032384,462297,876807,198384,519764,598704,239747,754757,193444,15470,585668,148152,404021,671185,395670) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001483s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540765 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540765 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002616s ]