SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001376s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50254 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50254 [ RunTime:0.001646s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (949084,768149,312389,229733,590119,527500,472216,87510,1011762,787606,558172,447968,174403,687842,968085,615081,233179,417824,178100,118068,697324,115055,618557,789739,669698,485701,948038,185253,352375,720270,79337,758895,733098,199697,128988,486143,446185,940598,150281,955424,522279,785997,315721,727139,992542,321037,138739,282572,717547,608802,809686,818715,847888,653167,870558,321133,932762,728706,755227,649146) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001099s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50254 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50254 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]