SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 564213 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 564213 [ RunTime:0.002900s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (741705,1025755,704919,752407,611837,552815,893768,621411,146482,927274,848533,973920,473034,949431,216515,1014680,486192,542420,174649,274905,864473,97736,534518,176578,448374,507127,671009,93362,271509,486491,200289,610873,460687,359000,903509,905641,424758,960016,1030012,547843,499878,279006,340144,307420,781211,966018,134873,921429,103988,908718,225283,206492,332630,527104,327207,635355,372200,1037435,511385,539944) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001088s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 564213 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 564213 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]