SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001334s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 386014 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 386014 [ RunTime:0.001887s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (495287,827580,314040,94940,130602,724465,199361,976696,432652,886454,301360,748746,388270,124648,104754,848841,537245,201458,880761,1033805,470520,591512,621006,570835,261960,527850,95805,125198,676508,858971,87279,847096,97370,650880,384383,8136,491596,422550,616450,711569,274312,117162,530178,334152,259689,257787,133324,740058,655080,128454,450748,636565,148934,312028,72368,573667,972558,127038,322469,283665) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 386014 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 386014 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000655s ]