SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000920s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1035678 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1035678 [ RunTime:0.002724s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (722913,483562,203973,320447,121698,651916,908766,600050,46520,978473,27434,154094,90632,921014,476401,120547,880362,56361,540706,547672,456404,32975,662917,623423,473068,799017,343487,564633,939366,69459,524930,165453,900568,285186,871018,723239,827043,604553,254954,174289,664415,917707,920985,50713,527771,185425,848715,481772,179203,619215,356683,670932,46983,380612,283258,263716,986844,598763,704769,864520) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001030s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1035678 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1035678 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000465s ]