SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 530706 LIMIT 1 [ RunTime:0.000292s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 530706 [ RunTime:0.001898s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (13314,618414,539604,495225,556538,987572,144821,661835,601137,533577,720959,579019,739946,671993,130737,1025391,508454,1012468,141034,468623,507526,344203,714665,512739,439067,194826,207656,490990,127506,481449,332540,98941,6369,526710,209880,896243,300636,428544,51869,831819,410015,129839,674932,606327,445423,489882,873639,951955,772479,430896,545284,527638,342095,783707,603606,199669,818684,494787,1014751,657775) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000998s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 530706 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 530706 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]