SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000992s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 323292 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 323292 [ RunTime:0.002751s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (414088,109841,30503,424803,762766,1029698,607454,287549,118004,582871,107229,97724,307404,722080,304062,1627,463613,863179,232581,859276,334690,326223,881260,1022097,793894,439928,889747,294222,562573,884798,976082,637914,289918,268307,316978,159216,811092,1044996,239131,579284,157840,764128,562975,591214,339670,566800,457770,893192,606109,595381,354733,737050,272762,11075,81353,402908,101661,566104,338397,1008147) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001069s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 323292 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 323292 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000590s ]