SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042685 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042685 [ RunTime:0.001589s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (968422,2637,16116,231410,148936,267205,16178,638294,813638,20095,442148,493181,10442,163374,193924,25625,262569,772759,178526,921509,33679,150865,769195,324282,321259,264629,361805,909692,682101,934694,166236,793941,455509,698939,17944,679216,76842,171248,580021,356995,529559,846333,482017,82382,258541,555716,795574,194839,940241,552739,445499,1021955,515379,331478,550854,127395,593896,955851,438232,435427) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001324s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042685 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042685 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000483s ]