SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001393s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 464691 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 464691 [ RunTime:0.002582s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (87156,221660,936543,803262,725523,1038848,934202,398286,509149,650061,926722,295955,419562,1040898,542546,546950,903955,777780,536985,934563,942891,74271,255550,180791,1033704,494701,272776,415423,775359,316940,171006,488737,5399,38899,612998,962165,569124,320555,383130,1042382,849556,1035408,989626,354962,72892,169457,582782,131478,29016,1014513,900723,312512,198432,98575,519873,637065,380232,673944,57409,460006) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 464691 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 464691 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000519s ]