SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001444s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540280 LIMIT 1 [ RunTime:0.000709s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540280 [ RunTime:0.006511s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (728444,166717,314273,1016309,851489,797442,92901,415849,383774,18307,1016534,458339,707582,519534,132651,612522,924302,40301,355227,936815,755254,902837,629617,366029,730907,998914,747980,106775,1007641,227530,757137,879841,446987,474054,221772,1027889,686126,756250,464392,267812,273190,430464,63610,791690,434,948024,306825,409148,679833,838587,1014470,849944,970345,713646,200259,409991,1016209,48851,188255,391639) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002513s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540280 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000901s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540280 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001129s ]