SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003519s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510648 LIMIT 1 [ RunTime:0.004000s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510648 [ RunTime:0.005773s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (111106,418663,656440,651866,815246,931377,1008895,58190,313540,507954,963807,574671,32412,46431,796983,265847,31706,931708,781351,1010561,992058,994832,20374,303310,537771,531747,808481,903444,355486,72399,638789,1007677,772525,685854,854480,312155,809372,988971,700471,536384,958363,828561,328696,213060,598638,700239,256486,409708,1030678,907617,393661,99856,385541,882693,120812,515955,796771,196821,98505,571874) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.032172s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510648 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000461s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510648 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000481s ]