SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001448s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043738 LIMIT 1 [ RunTime:0.000620s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043738 [ RunTime:0.004155s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (548175,196437,542785,363168,489558,413110,252650,464560,673958,850419,327230,47696,818710,608257,950987,46158,413105,1027382,771976,1028731,208295,408545,888486,156310,336193,283293,778034,892516,119925,161833,503330,408997,776043,680588,222064,943868,821342,965060,638777,88395,989821,694904,288660,211545,985048,409336,85346,332794,464899,921980,120322,508943,767050,836597,70046,716191,931825,22107,470524,906056) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001536s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043738 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043738 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000806s ]