SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002053s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1004840 LIMIT 1 [ RunTime:0.000890s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1004840 [ RunTime:0.001741s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (388315,989198,97959,592525,293320,1043628,894664,342121,17505,831351,2120,798833,779362,841711,159410,682071,814028,852780,1000038,709978,181006,365052,539741,331405,48226,974138,450277,510138,834224,45458,804353,718272,868355,878676,849793,688805,1037860,592844,177913,949172,538163,333390,241302,573998,688102,176702,774458,926711,1021665,235888,624779,1024463,706107,739179,677812,323954,804118,551458,501439,517079) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000930s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1004840 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1004840 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000430s ]