SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 464733 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 464733 [ RunTime:0.002305s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (33858,67805,630287,241459,339397,431689,953575,275024,350763,651292,274974,55870,719101,280270,381493,81488,615090,12538,522854,774712,402288,20217,265405,593049,334391,566453,669409,850734,907293,484334,1046321,54155,35590,648556,880518,954652,620354,650376,634092,220371,899344,407932,801061,781656,351453,895095,83773,35501,901043,772447,577286,426094,913506,281771,1046841,648934,1042260,890412,238945,625419) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003973s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 464733 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000573s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 464733 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001223s ]