SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 519686 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 519686 [ RunTime:0.001999s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (535686,984426,278973,786213,1014300,491533,556083,235288,700837,904371,95648,732678,317172,923188,518543,178453,311071,537143,389346,168872,288507,540362,133496,786484,841434,632666,797780,122173,668850,430408,629502,975235,687679,627873,56777,473305,858435,504707,345915,371440,602840,45371,869634,768659,774749,340676,905704,1000684,664878,79420,622810,821114,425569,365368,217923,909192,176407,825852,710290,824391) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 519686 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 519686 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000471s ]