SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 356300 LIMIT 1 [ RunTime:0.000290s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 356300 [ RunTime:0.002497s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (91002,546675,517455,549033,482759,496814,553390,785059,527682,1015097,552212,566873,709360,452799,23226,523122,257030,706441,769676,491122,899476,737611,457004,453830,24885,776755,933489,344774,377743,763684,88555,443052,529517,756753,847439,758928,989141,8785,757524,829818,902897,597566,213754,628107,585987,85072,421779,877432,10166,677433,1015872,251846,618971,211569,644485,124501,467397,345634,119697,659626) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 356300 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000470s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 356300 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004637s ]