SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 53043 LIMIT 1 [ RunTime:0.000299s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 53043 [ RunTime:0.003528s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (543923,1447,608375,581885,122094,959296,705054,996825,948325,998044,480359,136309,786707,628122,243524,842988,745637,107211,132402,690939,920077,718867,899370,749246,401888,955276,924964,751233,175055,746767,347179,862854,385877,75663,417533,1018299,914629,764962,355080,126980,905697,705569,363402,115363,90669,634951,114647,941403,796154,617450,96649,777099,324377,678300,784546,983132,1014822,555634,182185,780742) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 53043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000471s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 53043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000374s ]