SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001714s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531253 LIMIT 1 [ RunTime:0.000296s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531253 [ RunTime:0.001975s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (408982,176348,893871,483716,907993,442930,634938,262246,450980,1029307,438485,765857,819302,856888,400341,857671,808064,182800,940830,942666,121118,968159,13009,1022604,64910,837728,430470,663896,591387,574482,895079,434057,593933,298285,738641,660188,1038805,280073,377923,694959,3092,221830,846730,372854,260237,434835,937866,399873,573230,536709,344327,386557,104139,384360,482892,1260,873616,1216,266108,775977) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000924s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531253 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531253 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000622s ]