SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545110 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545110 [ RunTime:0.001948s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (818667,1023893,842500,384022,749551,95865,251887,377090,307238,8342,330942,994125,237066,191078,378254,479037,336881,997420,414456,554080,348696,888763,402733,406216,572017,530007,757467,845386,147916,166017,198642,360321,222893,193822,407137,995766,704799,542693,616268,992456,513242,673715,637423,136491,1041505,690657,159908,607640,52938,309092,189147,1027977,715159,622314,134163,726879,457037,126652,673089,901093) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545110 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545110 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]