SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001396s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 529029 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 529029 [ RunTime:0.002062s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (668996,294145,136470,590699,263787,694446,624015,311746,949583,480086,508858,151846,173086,906814,159252,364828,739755,231971,114358,482346,478314,656236,143530,527348,561482,925831,494818,343281,248213,128614,676196,591957,829580,1035919,417299,459720,126806,616688,1008569,626371,13805,427657,403269,315187,769692,609436,294348,383256,968870,653478,1011426,974681,72095,759812,262899,707261,1007470,35217,184191,527686) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001696s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 529029 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 529029 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]