SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 348271 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 348271 [ RunTime:0.001570s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (506103,704824,538757,995218,750441,381060,1038291,436149,369005,674799,128341,492854,920461,191281,321020,293459,315399,774580,725040,1048285,241105,778965,993717,232601,1036575,979925,906831,317710,66214,100612,67795,523467,122932,713569,360663,823103,297052,271318,527166,734749,297716,441787,1004834,854321,1033164,1027772,601034,939938,703832,723309,641132,813942,639966,31223,929178,866810,1024439,568801,128061,681134) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 348271 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000539s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 348271 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]