SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 422923 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 422923 [ RunTime:0.002256s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (610681,935489,847880,510516,111324,888706,442350,587237,76072,894941,957739,540491,469264,294543,563561,161973,961245,177088,450347,397462,477909,928772,693070,516423,879033,744017,410028,473766,47269,359225,446872,821917,1045992,322554,833602,350898,521913,454718,182771,110333,923832,850434,258996,241997,217042,618989,642668,760990,15007,736560,752218,663700,968394,65500,602056,931763,647174,634163,705761,272056) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001652s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 422923 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 422923 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000434s ]