SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001300s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 318014 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 318014 [ RunTime:0.001870s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (135584,676252,640725,1040065,401403,456533,41860,352694,209570,629974,335748,711000,251321,646035,667818,864422,519841,988472,181592,674932,643178,591409,1041182,46061,546009,536498,221723,985397,1031954,603239,14628,995883,414365,330307,181172,815202,697399,844394,869176,696627,481354,929131,115526,104136,395445,909457,795786,24136,371317,264227,151617,776255,744401,506401,308883,356567,528453,132884,114845,120209) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001701s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 318014 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004980s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 318014 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]