SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002529s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 549253 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 549253 [ RunTime:0.002269s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (316563,3195,939993,785215,901840,478635,302182,598020,207913,44487,134761,268197,943115,390181,22986,460408,74927,1005750,205847,1006734,604475,542334,189232,685829,655019,323503,903188,271949,1026451,369871,365886,816869,280100,487420,122837,274901,798572,1022052,409134,1035933,1011806,535326,782619,293685,992725,413384,464753,800856,766161,412239,953332,1035244,381413,789723,856831,70491,434380,996247,335375,300740) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001068s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 549253 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 549253 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000566s ]