SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510892 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510892 [ RunTime:0.001655s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (569450,664899,421481,730061,979003,705000,817435,906308,603330,472478,421077,19598,430999,140477,792570,542736,1034017,960391,424398,1026939,183765,286335,363264,116829,446524,590904,287783,1043761,506396,255778,886899,709758,181566,445810,245681,604997,565578,441299,200622,666228,563996,985685,420077,481652,192501,697137,372145,743943,455596,422621,824168,14914,451945,414615,59682,489910,90836,69833,436481,63153) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001019s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510892 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510892 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]