SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 522948 LIMIT 1 [ RunTime:0.000425s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 522948 [ RunTime:0.001945s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (282850,431851,755361,250664,237132,152604,818463,918850,321880,377875,143098,946250,132038,764660,1017720,295640,734888,633437,133447,966516,140293,832231,437682,231624,713186,740906,336659,1041612,573749,110210,300990,830492,872255,85920,977925,18169,906420,523909,781313,954248,312298,365341,340160,737110,100929,94845,322863,779614,601910,126042,789605,908859,972075,907105,218842,611945,187994,977056,831745,754758) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 522948 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000557s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 522948 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000442s ]