SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001466s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 118896 LIMIT 1 [ RunTime:0.000687s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 118896 [ RunTime:0.002429s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (433424,488542,735439,127128,716208,268314,474527,184842,536431,954336,212359,108329,383373,862705,418162,244680,956451,112112,493519,789212,995308,954941,890571,721827,455522,231649,527360,869980,827533,240828,332549,916582,782099,144996,402091,776799,310520,1010697,311563,39634,325480,212217,993293,278414,418458,981788,959715,303850,279283,806347,653851,901091,63205,598261,583473,658018,532083,919709,654870,566913) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 118896 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000894s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 118896 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000457s ]