SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414320 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414320 [ RunTime:0.001687s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (225684,72259,932958,488368,819306,273806,318340,345375,565632,956925,677890,1009800,598247,601138,887791,388633,724907,378484,505937,490156,753010,1032226,852134,729585,214181,564637,303810,51387,515719,1040091,428206,584773,194299,300457,147484,254335,458697,787504,94704,75363,17917,180878,921671,940367,530395,595855,383685,219828,196206,549531,274118,738436,781111,371042,1005951,653376,1014833,937609,111286,209594) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414320 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000314s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414320 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]