SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 522592 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 522592 [ RunTime:0.001977s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (615844,1045812,820807,1026291,355613,676181,905700,364622,584571,353214,666792,1035566,384709,302525,884147,356230,590992,109683,671126,203167,721884,385637,1047366,384960,404702,1016427,961010,482707,652952,611828,1031868,209490,290896,709667,105079,643165,530523,245134,761570,743983,377506,713972,170875,394488,308716,126359,475786,69252,418467,49951,1017365,597190,66848,303725,321548,436488,518123,1045090,117639,396366) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 522592 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000503s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 522592 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]