SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 532291 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 532291 [ RunTime:0.004507s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (240930,180214,677710,13275,547756,310665,887968,388852,641134,155324,825484,834346,955773,933060,24368,946577,308186,93377,249786,878368,329365,959059,845680,233430,211285,296001,453813,156138,120912,197715,887403,126766,560253,826,59186,798612,176318,974842,938534,1004771,1034760,657190,669556,384137,631062,968095,455728,260915,682602,657333,735748,491110,965794,457810,625800,977304,887222,933928,781839,413065) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 532291 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 532291 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]