SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 452018 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 452018 [ RunTime:0.001550s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (258390,861944,870839,303806,898896,52066,659008,310479,1045588,381746,846101,811750,308131,878877,147794,336187,708821,836246,55314,1042826,196149,242480,126039,931482,903265,428299,1027230,529512,758043,139075,938039,977810,147883,586547,508825,847583,997244,808554,831075,673723,723088,797262,825128,343794,984141,148655,444484,792718,647714,144107,785924,948586,256489,599935,771479,856606,9956,576032,32452,327413) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001903s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 452018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000519s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 452018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]