SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003797s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 100729 LIMIT 1 [ RunTime:0.001396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 100729 [ RunTime:0.002472s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (115805,1033304,323095,466840,195529,835049,76981,421183,695734,149048,554943,1029734,541928,161554,320957,431982,1012427,623529,395373,681124,76439,415817,227542,499606,681151,291183,26677,712088,1019508,916262,1030043,158839,113471,106698,203811,255681,166103,955002,244183,754084,16800,411536,24040,545741,559119,661782,274512,138913,841484,799293,359979,32122,181865,840159,558712,413233,360425,245222,909542,112843) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 100729 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000646s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 100729 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001410s ]