SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50913 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50913 [ RunTime:0.001577s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (441799,852067,334578,770630,27851,1010905,800730,495882,218711,933147,453403,274897,265248,54240,643752,836446,453978,278675,445541,26118,314747,903827,578424,313317,335377,219267,359267,93351,768433,526880,915053,28028,14973,257766,535660,439802,343873,693409,66710,406620,751502,482234,110007,769865,481979,381223,647185,310141,388073,555309,720813,344152,182624,462067,657483,999962,85975,417307,210147,923400) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000994s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50913 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50913 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000441s ]