SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001475s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405974 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405974 [ RunTime:0.005969s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (945887,792064,842107,1009642,618239,1014531,737486,761033,798465,711416,288727,111647,924808,482686,114643,694182,428152,877488,298555,916308,156339,351509,807343,20506,421317,945626,756367,956593,505047,835706,962862,763065,2310,353034,486424,521454,1037103,499324,1023002,480475,313222,298887,341119,186148,55764,816174,43587,810723,709290,959223,796149,720708,40102,752976,972844,763666,106921,1020450,84563,997752) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002891s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405974 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000579s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405974 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000717s ]