SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017174 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017174 [ RunTime:0.002919s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (810015,373965,618768,36905,471341,593295,25692,839376,168664,676108,130496,940085,615747,719162,1020201,30399,867126,414456,666351,564850,143283,519275,627896,677262,531295,170652,6395,408609,877889,423203,186219,73279,782074,677039,185863,279040,1001141,912219,713913,200018,219217,718329,315657,237139,657794,726983,1026949,341563,94411,911856,1021997,813871,162799,475225,486297,661596,36652,9243,226625,910987) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001273s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017174 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000456s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017174 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003296s ]