SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017799 LIMIT 1 [ RunTime:0.000293s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017799 [ RunTime:0.001705s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (111699,566201,119997,427951,1020053,143275,738697,729215,200736,970187,843957,764318,1006481,965580,218019,680893,427404,726244,827690,624684,18195,539071,948372,384936,554453,64894,149662,408693,853250,685270,232243,907057,816759,548189,17229,181697,131399,722539,839636,143290,862771,680260,656618,628764,8828,1045161,19513,184733,42430,1025070,897799,612769,745966,51291,359077,370190,164197,987734,648374,78861) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000995s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017799 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017799 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000606s ]