SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001693s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 428016 LIMIT 1 [ RunTime:0.000645s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 428016 [ RunTime:0.001927s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (4267,425989,635547,257008,619162,1020123,850823,257703,70546,742689,1004787,885898,164142,151348,240940,47946,381356,223286,670211,958913,173885,691781,95899,128679,635796,356616,834132,869193,126750,579881,173349,177613,892923,760533,336480,1017763,552691,962491,692017,726801,720263,595842,326012,156728,522260,783537,558488,545167,201633,512392,105352,806979,923304,483154,97406,867557,118270,132464,245830,195784) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002218s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 428016 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000510s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 428016 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]