SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406909 LIMIT 1 [ RunTime:0.000883s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406909 [ RunTime:0.001916s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (120063,410255,408526,107366,193833,680884,430789,801667,344050,94488,272361,438270,1008155,39427,400792,794729,670214,982959,492110,864875,325090,426130,284602,120941,578424,3636,166688,916734,743838,377304,863196,620864,818381,100647,872218,389775,252627,735625,172193,27470,469550,419520,117816,107829,317368,488614,48172,357887,621721,827827,306345,597957,757973,755478,334130,407157,175400,910231,428418,380731) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406909 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406909 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000667s ]