SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 450067 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 450067 [ RunTime:0.002311s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (643455,100354,779988,437853,601493,95558,184950,1026244,403119,416073,745624,215576,961997,129333,690540,456157,409355,688363,118062,744787,397855,526859,69968,457409,281848,224681,658564,757852,924360,38118,124526,873647,766404,49813,985968,2546,940332,761626,327859,62204,947880,335926,180720,47142,984583,62655,504535,361402,329942,592669,69695,363989,998620,89281,510215,567994,335193,106220,586450,504768) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001047s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 450067 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 450067 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]