SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 291590 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291590 [ RunTime:0.001781s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (998993,137621,50015,496162,896717,222871,775069,1005775,1025208,974084,864611,659366,883602,760870,644233,119849,120796,487608,246476,579773,524917,966107,684301,128267,579542,857088,597336,737605,610974,765754,137636,196467,20791,708834,1000671,591963,847519,775780,503498,452048,187536,967333,701806,991849,42529,342018,527844,629086,1045792,242812,7272,888366,780353,430381,379844,567317,431391,821615,759741,805010) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291590 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291590 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000695s ]