SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 4606 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 4606 [ RunTime:0.002055s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (492484,885564,687060,241500,756772,230573,857426,999972,814068,843061,374911,878410,122179,724323,449487,997575,906425,235875,473920,938480,738026,410621,692329,165514,327915,169972,885826,604132,708645,526224,1008036,504200,327544,468498,917821,217042,111930,77513,757399,323830,802054,140545,797972,357713,830608,132733,905367,753846,271066,987177,616484,839620,641473,938861,290738,978439,55479,551284,136360,241907) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002787s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 4606 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000652s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 4606 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000632s ]