SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1036100 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1036100 [ RunTime:0.001941s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (753579,366047,547767,736950,400716,432326,316472,460381,246838,238531,283021,986051,141336,935473,849083,223301,625147,501781,883374,539586,903408,89468,594902,863436,402286,848455,393569,180322,958151,665559,169789,6626,641175,114196,437476,524652,727495,1035730,278891,282873,765911,817516,633382,280690,445635,990666,955028,362473,894226,920669,405148,777453,903405,540229,292006,451530,922780,649664,851894,33644) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000968s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1036100 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1036100 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000430s ]