SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520490 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520490 [ RunTime:0.002216s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (98811,263398,963872,154180,32366,671063,1048273,369257,15756,448732,8489,899279,1005092,281265,2448,246902,160879,500470,605612,57875,426455,782051,130652,83356,985843,812488,802143,718006,512439,416754,48817,336912,512589,540000,736624,841820,858645,1000938,890951,462864,542895,931799,332930,380920,955119,830801,227092,145859,504632,558642,606343,594182,973246,80716,56880,349714,746094,473162,411482,90916) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001075s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520490 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520490 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001730s ]