SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 249828 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 249828 [ RunTime:0.001723s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (499714,809923,847039,162477,14679,360227,528666,863567,414732,590666,693409,783837,186892,269166,1002742,806751,634610,963189,207511,697332,290009,1046166,910071,156595,195683,312114,142974,667034,784490,964716,196481,959039,712670,4524,699380,540164,776565,674925,792800,199181,629316,578072,323147,865836,345501,534777,550926,189973,248491,896827,626269,306335,589096,1047809,245204,831939,159782,21303,874547,809056) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 249828 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 249828 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]